﻿CREATE TABLE `d5_user_login` (
  `UID` int(8) NOT NULL auto_increment,
  `LOGIN_NAME` varchar(24) default NULL,
  `LOGIN_PASS` varchar(32) default NULL,
  PRIMARY KEY  (`UID`),
  KEY `LOGIN_NAME` (`LOGIN_NAME`,`LOGIN_PASS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `d5_conf_home` (
  `ID` int(4) NOT NULL auto_increment,
  `NAME` varchar(50) default NULL COMMENT 'content''s title',
  `PLACE` varchar(4) default NULL COMMENT 'where it will be show(L0-L4...)',
  `DRIVER` varchar(255) default NULL COMMENT 'witch file will be load',
  PRIMARY KEY  (`ID`),
  KEY `PLACE` (`PLACE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ת��ݿ�

$sql="select * from d5_user";
	$db=new db_mouse();
	$db->query($sql);
	
	if($db->fetch_array())
	{
		do
		{
			$sql="insert into d5_user_login set ";
			$sql.="UID = '{$db->row['UID']}',";
			$sql.="LOGIN_NAME = '{$db->row['USERNAME']}',";
			$sql.="LOGIN_PASS = '{$db->row['PASSWORD']}'";
			mysql_query($sql);
			echo "Done";
		}while($db->fetch_array());
	}

ALTER TABLE `d5_user` DROP `AID`, DROP `PASSWORD`;

ת���

$sql="select * from d5_photo";
	$db=new db_mouse();
	$db->query($sql);
	
	if($db->fetch_array())
	{
		do
		{
			$dress=str_replace("../","",$db->row['FNAME']);
			$sql="update d5_photo set ";
			$sql.="FNAME = '{$dress}' where ID='{$db->row['ID']}'";
			mysql_query($sql);
		}while($db->fetch_array());
	}


$sql="select * from d5_album";
	$db=new db_mouse();
	$db->query($sql);
	
	if($db->fetch_array())
	{
		do
		{
			$dress=str_replace("../","",$db->row['AIMG']);
			$sql="update d5_album set ";
			$sql.="AIMG = '{$dress}' where UID='{$db->row['UID']}'";
			mysql_query($sql);
		}while($db->fetch_array());
	}



ALTER TABLE `d5_album` CHANGE `UID` `ID` INT( 8 ) NOT NULL DEFAULT '0' 

ALTER TABLE `d5_album` ADD `UID` INT( 8 ) NULL ;

ALTER TABLE `d5_album` CHANGE `ID` `ID` INT( 8 ) NOT NULL AUTO_INCREMENT 



������ݿ�

$sql="select * from d5_album";
	$db=new db_mouse();
	$db->query($sql);
	
	if($db->fetch_array())
	{
		do
		{
			$sql="update d5_album set ";
			$sql.="UID = '{$db->row['ID']}' ";
			$sql.="where ID='{$db->row['ID']}'";
			mysql_query($sql);
		}while($db->fetch_array());
	}

ALTER TABLE `d5_album` DROP INDEX `UID` ,ADD INDEX `UID` ( `ID` , `ANAME` , `AHOT` , `ASEL` , `UID` ) ;

ALTER TABLE `d5_user` ADD `USESSION` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ;

ALTER TABLE `d5_user` ADD `USERHEAD` VARCHAR( 120 )  AFTER `USERNAME` ;

ALTER TABLE `d5_album` ADD `ALOCK` VARCHAR( 32 ) NULL  AFTER `ASEL` ;

ALTER TABLE `d5_album` ADD INDEX ( `ALOCK` ) ;

ALTER TABLE `d5_album` DROP `ATEMP`  

ALTER TABLE `d5_photo` CHANGE `ALLOWUID` `ALBUMID` INT( 8 ) NULL DEFAULT NULL;

UPDATE `d5_photo` SET ALBUMID=UID where ALBUMID is NULL;

ALTER TABLE `d5_album` ADD `ATYPE` CHAR( 1 ) NULL AFTER `ID` ;

ALTER TABLE `d5_album` ADD INDEX ( `ATYPE` ) ;

ALTER TABLE `d5_album` ADD `ATOP` INT( 6 ) NOT NULL DEFAULT '0' AFTER `AHOT` ;

ALTER TABLE `d5_album` ADD INDEX ( `ATOP` ) ;

CREATE TABLE `d5_supervideo_temp` (
  `ID` int(8) NOT NULL auto_increment,
  `FNAME` varchar(20) default NULL,
  `UID` int(8) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `UID` (`UID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `d5_user` CHANGE `UID` `UID` INT( 8 ) NOT NULL AUTO_INCREMENT;

ALTER TABLE `d5_photo` CHANGE `UID` `UID` INT( 8 ) NULL DEFAULT NULL;

CREATE TABLE `d5_supervideo_main` (
  `ID` int(10) NOT NULL auto_increment,
  `SVPATH` varchar(255) default NULL,
  `SVNAME` varchar(90) default NULL,
  `SVINFO` text,
  `SVKEY` varchar(255) default NULL,
  `SVCHANNEL` int(3) default NULL,
  `SVLEVEL` tinyint(1) default NULL,
  `SVFROM` tinyint(1) default NULL,
  `SVHOT` int(7) default 0,
  `SVTOP` int(6) default 0,
  `SVWDATE` int(11) default NULL,
  `SVPASS` tinyint(1) default NULL,
  `UID` int(8) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `SVNAME` (`SVNAME`,`SVKEY`,`SVCHANNEL`,`SVLEVEL`,`SVPASS`,`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `d5_album` (`ATYPE`, `AIMG`, `AINFO`, `ANAME`, `AHOT`, `ATOP`, `ASEL`, `ALOCK`, `AUPDATE`, `UID`) VALUES 
('S', NULL, NULL, 'Ӱ�Ӿ糡', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '��������', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '������Ϸ', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, 'ԭ�����', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '����̨', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '����¼', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '���ƽ�', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, '���վ��', 0, 0, 0, NULL, NULL, -1),
('S', NULL, NULL, 'ʱ�н��', 0, 0, 0, NULL, NULL, -1);

ALTER TABLE `d5_mtv_basic` ADD `mtv_hot` INT( 6 ) NOT NULL DEFAULT '0',
ADD `mtv_top` INT( 6 ) NOT NULL DEFAULT '0';

ALTER TABLE `d5_photo` ADD `FTNAME` VARCHAR( 100 ) NULL AFTER `FNAME` ;
ALTER TABLE `d5_photo` CHANGE `FNAME` `FNAME` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `d5_front` ADD `BGTPATH` VARCHAR( 120 ) NULL ;
ALTER TABLE `d5_user` CHANGE `UID` `UID` INT( 8 ) NOT NULL